{"statement":"(SELECT tbl_mock_001.id, tbl_mock_001.mock_022, tbl_mock_001.mock_007, tbl_mock_068.mock_087, tbl_mock_068.mock_071, tbl_mock_001.mock_003, tbl_mock_001.mock_014 AS mock_126, tbl_mock_001.mock_015 AS mock_127, tbl_mock_001.mock_021 AS mock_064, tbl_mock_037.mock_099, tbl_mock_037.id AS mock_128, if((abs(timestampdiff(DAY, tbl_mock_001.mock_014, tbl_mock_001.mock_015))) \u003e 0, 1, 0) AS mock_129\nFROM db_mock_000.tbl_mock_001 LEFT OUTER JOIN db_mock_000.tbl_mock_043 ON tbl_mock_043.id \u003d tbl_mock_001.mock_022 LEFT OUTER JOIN db_mock_000.tbl_mock_068 ON tbl_mock_068.id \u003d tbl_mock_043.mock_012 LEFT OUTER JOIN db_mock_000.tbl_mock_037 ON tbl_mock_037.id \u003d tbl_mock_001.mock_037 RIGHT OUTER JOIN ((SELECT DISTINCT tbl_mock_132.mock_121\nFROM db_mock_000.tbl_mock_111 AS tbl_mock_132 LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_132.mock_121 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_132.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200)\nWHERE ((((((tbl_mock_132.mock_030 IN (1200)) AND (tbl_mock_132.mock_024 \u003d 6)) AND (tbl_mock_132.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_132.mock_115 \u003d 2)) AND (tbl_mock_133.mock_024 \u003d 6)) AND (tbl_mock_133.mock_016 \u003d 1)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-19 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-19 00:00:00\u0027))) UNION (SELECT DISTINCT tbl_mock_132.mock_121\nFROM db_mock_000.tbl_mock_123 AS tbl_mock_132 LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_135 ON tbl_mock_135.id \u003d tbl_mock_132.mock_121 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_132.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200)\nWHERE ((((((tbl_mock_132.mock_030 IN (11980)) AND (tbl_mock_132.mock_024 \u003d 6)) AND (tbl_mock_132.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_132.mock_115 \u003d 2)) AND (tbl_mock_135.mock_024 \u003d 6)) AND (tbl_mock_135.mock_016 \u003d 1)) AND ((tbl_mock_135.mock_014 \u003c\u003d \u00272022-12-19 23:59:59\u0027) AND (tbl_mock_135.mock_015 \u003e\u003d \u00272022-12-19 00:00:00\u0027)))) tbl_mock_131 ON tbl_mock_131.mock_121 \u003d tbl_mock_001.id RIGHT OUTER JOIN ((SELECT DISTINCT tbl_mock_137.mock_121\nFROM db_mock_000.tbl_mock_111 AS tbl_mock_137 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_137.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200) LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_137.mock_121\nWHERE (((((tbl_mock_137.mock_024 \u003d 6) AND (tbl_mock_137.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_133.mock_016 \u003d 1)) AND (tbl_mock_133.mock_024 \u003d 6)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-19 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-19 00:00:00\u0027))) AND (((((tbl_mock_137.mock_108 \u003d \u0027activity\u0027) AND (tbl_mock_137.mock_115 !\u003d 0)) AND (tbl_mock_137.mock_030 IN (1200))) OR (tbl_mock_137.mock_116 IN (((SELECT tbl_mock_111.mock_121\nFROM db_mock_000.tbl_mock_111\nWHERE (((tbl_mock_111.mock_108 \u003d \u0027deal\u0027) AND (tbl_mock_111.mock_121 \u003d tbl_mock_137.mock_116)) AND (tbl_mock_111.mock_112 !\u003d 0)) AND (tbl_mock_111.mock_030 IN (1200))))))) OR (tbl_mock_137.mock_012 IN (((SELECT tbl_mock_111.mock_121\nFROM db_mock_000.tbl_mock_111\nWHERE (((tbl_mock_111.mock_108 \u003d \u0027customer\u0027) AND (tbl_mock_111.mock_121 \u003d tbl_mock_137.mock_012)) AND (tbl_mock_111.mock_112 !\u003d 0)) AND (tbl_mock_111.mock_030 IN (1200)))))))) UNION (SELECT DISTINCT tbl_mock_138.mock_121\nFROM db_mock_000.tbl_mock_123 AS tbl_mock_138 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_138.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200) LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_138.mock_121\nWHERE (((((tbl_mock_138.mock_024 \u003d 6) AND (tbl_mock_138.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_133.mock_016 \u003d 1)) AND (tbl_mock_133.mock_024 \u003d 6)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-19 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-19 00:00:00\u0027))) AND (((((tbl_mock_138.mock_108 \u003d \u0027activity\u0027) AND (tbl_mock_138.mock_115 !\u003d 0)) AND (tbl_mock_138.mock_030 IN (11980))) OR (tbl_mock_138.mock_116 IN (((SELECT tbl_mock_123.mock_121\nFROM db_mock_000.tbl_mock_123\nWHERE (((tbl_mock_123.mock_108 \u003d \u0027deal\u0027) AND (tbl_mock_123.mock_121 \u003d tbl_mock_138.mock_116)) AND (tbl_mock_123.mock_112 !\u003d 0)) AND (tbl_mock_123.mock_030 IN (11980))))))) OR (tbl_mock_138.mock_012 IN (((SELECT tbl_mock_123.mock_121\nFROM db_mock_000.tbl_mock_123\nWHERE (((tbl_mock_123.mock_108 \u003d \u0027customer\u0027) AND (tbl_mock_123.mock_121 \u003d tbl_mock_138.mock_012)) AND (tbl_mock_123.mock_112 !\u003d 0)) AND (tbl_mock_123.mock_030 IN (11980))))))))) tbl_mock_136 ON tbl_mock_136.mock_121 \u003d tbl_mock_001.id\nWHERE ((tbl_mock_001.mock_016 \u003d 1) AND (1 \u003d 1)) AND (tbl_mock_001.mock_024 \u003d 6) ORDER BY if((abs(timestampdiff(DAY, tbl_mock_001.mock_014, tbl_mock_001.mock_015))) \u003e 0, 1, 0) DESC, tbl_mock_001.mock_014 DESC, tbl_mock_001.id DESC  LIMIT 7) UNION (SELECT tbl_mock_001.id, tbl_mock_001.mock_022, tbl_mock_001.mock_007, tbl_mock_068.mock_087, tbl_mock_068.mock_071, tbl_mock_001.mock_003, tbl_mock_001.mock_014 AS mock_126, tbl_mock_001.mock_015 AS mock_127, tbl_mock_001.mock_021 AS mock_064, tbl_mock_037.mock_099, tbl_mock_037.id AS mock_128, if((abs(timestampdiff(DAY, tbl_mock_001.mock_014, tbl_mock_001.mock_015))) \u003e 0, 1, 0) AS mock_129\nFROM db_mock_000.tbl_mock_001 LEFT OUTER JOIN db_mock_000.tbl_mock_043 ON tbl_mock_043.id \u003d tbl_mock_001.mock_022 LEFT OUTER JOIN db_mock_000.tbl_mock_068 ON tbl_mock_068.id \u003d tbl_mock_043.mock_012 LEFT OUTER JOIN db_mock_000.tbl_mock_037 ON tbl_mock_037.id \u003d tbl_mock_001.mock_037 RIGHT OUTER JOIN ((SELECT DISTINCT tbl_mock_132.mock_121\nFROM db_mock_000.tbl_mock_111 AS tbl_mock_132 LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_132.mock_121 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_132.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200)\nWHERE ((((((tbl_mock_132.mock_030 IN (1200)) AND (tbl_mock_132.mock_024 \u003d 6)) AND (tbl_mock_132.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_132.mock_115 \u003d 2)) AND (tbl_mock_133.mock_024 \u003d 6)) AND (tbl_mock_133.mock_016 \u003d 1)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-20 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-20 00:00:00\u0027))) UNION (SELECT DISTINCT tbl_mock_132.mock_121\nFROM db_mock_000.tbl_mock_123 AS tbl_mock_132 LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_135 ON tbl_mock_135.id \u003d tbl_mock_132.mock_121 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_132.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200)\nWHERE ((((((tbl_mock_132.mock_030 IN (11980)) AND (tbl_mock_132.mock_024 \u003d 6)) AND (tbl_mock_132.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_132.mock_115 \u003d 2)) AND (tbl_mock_135.mock_024 \u003d 6)) AND (tbl_mock_135.mock_016 \u003d 1)) AND ((tbl_mock_135.mock_014 \u003c\u003d \u00272022-12-20 23:59:59\u0027) AND (tbl_mock_135.mock_015 \u003e\u003d \u00272022-12-20 00:00:00\u0027)))) tbl_mock_131 ON tbl_mock_131.mock_121 \u003d tbl_mock_001.id RIGHT OUTER JOIN ((SELECT DISTINCT tbl_mock_137.mock_121\nFROM db_mock_000.tbl_mock_111 AS tbl_mock_137 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_137.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200) LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_137.mock_121\nWHERE (((((tbl_mock_137.mock_024 \u003d 6) AND (tbl_mock_137.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_133.mock_016 \u003d 1)) AND (tbl_mock_133.mock_024 \u003d 6)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-20 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-20 00:00:00\u0027))) AND (((((tbl_mock_137.mock_108 \u003d \u0027activity\u0027) AND (tbl_mock_137.mock_115 !\u003d 0)) AND (tbl_mock_137.mock_030 IN (1200))) OR (tbl_mock_137.mock_116 IN (((SELECT tbl_mock_111.mock_121\nFROM db_mock_000.tbl_mock_111\nWHERE (((tbl_mock_111.mock_108 \u003d \u0027deal\u0027) AND (tbl_mock_111.mock_121 \u003d tbl_mock_137.mock_116)) AND (tbl_mock_111.mock_112 !\u003d 0)) AND (tbl_mock_111.mock_030 IN (1200))))))) OR (tbl_mock_137.mock_012 IN (((SELECT tbl_mock_111.mock_121\nFROM db_mock_000.tbl_mock_111\nWHERE (((tbl_mock_111.mock_108 \u003d \u0027customer\u0027) AND (tbl_mock_111.mock_121 \u003d tbl_mock_137.mock_012)) AND (tbl_mock_111.mock_112 !\u003d 0)) AND (tbl_mock_111.mock_030 IN (1200)))))))) UNION (SELECT DISTINCT tbl_mock_138.mock_121\nFROM db_mock_000.tbl_mock_123 AS tbl_mock_138 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_138.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200) LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_138.mock_121\nWHERE (((((tbl_mock_138.mock_024 \u003d 6) AND (tbl_mock_138.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_133.mock_016 \u003d 1)) AND (tbl_mock_133.mock_024 \u003d 6)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-20 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-20 00:00:00\u0027))) AND (((((tbl_mock_138.mock_108 \u003d \u0027activity\u0027) AND (tbl_mock_138.mock_115 !\u003d 0)) AND (tbl_mock_138.mock_030 IN (11980))) OR (tbl_mock_138.mock_116 IN (((SELECT tbl_mock_123.mock_121\nFROM db_mock_000.tbl_mock_123\nWHERE (((tbl_mock_123.mock_108 \u003d \u0027deal\u0027) AND (tbl_mock_123.mock_121 \u003d tbl_mock_138.mock_116)) AND (tbl_mock_123.mock_112 !\u003d 0)) AND (tbl_mock_123.mock_030 IN (11980))))))) OR (tbl_mock_138.mock_012 IN (((SELECT tbl_mock_123.mock_121\nFROM db_mock_000.tbl_mock_123\nWHERE (((tbl_mock_123.mock_108 \u003d \u0027customer\u0027) AND (tbl_mock_123.mock_121 \u003d tbl_mock_138.mock_012)) AND (tbl_mock_123.mock_112 !\u003d 0)) AND (tbl_mock_123.mock_030 IN (11980))))))))) tbl_mock_136 ON tbl_mock_136.mock_121 \u003d tbl_mock_001.id\nWHERE ((tbl_mock_001.mock_016 \u003d 1) AND (1 \u003d 1)) AND (tbl_mock_001.mock_024 \u003d 6) ORDER BY if((abs(timestampdiff(DAY, tbl_mock_001.mock_014, tbl_mock_001.mock_015))) \u003e 0, 1, 0) DESC, tbl_mock_001.mock_014 DESC, tbl_mock_001.id DESC  LIMIT 7) UNION (SELECT tbl_mock_001.id, tbl_mock_001.mock_022, tbl_mock_001.mock_007, tbl_mock_068.mock_087, tbl_mock_068.mock_071, tbl_mock_001.mock_003, tbl_mock_001.mock_014 AS mock_126, tbl_mock_001.mock_015 AS mock_127, tbl_mock_001.mock_021 AS mock_064, tbl_mock_037.mock_099, tbl_mock_037.id AS mock_128, if((abs(timestampdiff(DAY, tbl_mock_001.mock_014, tbl_mock_001.mock_015))) \u003e 0, 1, 0) AS mock_129\nFROM db_mock_000.tbl_mock_001 LEFT OUTER JOIN db_mock_000.tbl_mock_043 ON tbl_mock_043.id \u003d tbl_mock_001.mock_022 LEFT OUTER JOIN db_mock_000.tbl_mock_068 ON tbl_mock_068.id \u003d tbl_mock_043.mock_012 LEFT OUTER JOIN db_mock_000.tbl_mock_037 ON tbl_mock_037.id \u003d tbl_mock_001.mock_037 RIGHT OUTER JOIN ((SELECT DISTINCT tbl_mock_132.mock_121\nFROM db_mock_000.tbl_mock_111 AS tbl_mock_132 LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_132.mock_121 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_132.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200)\nWHERE ((((((tbl_mock_132.mock_030 IN (1200)) AND (tbl_mock_132.mock_024 \u003d 6)) AND (tbl_mock_132.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_132.mock_115 \u003d 2)) AND (tbl_mock_133.mock_024 \u003d 6)) AND (tbl_mock_133.mock_016 \u003d 1)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-21 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-21 00:00:00\u0027))) UNION (SELECT DISTINCT tbl_mock_132.mock_121\nFROM db_mock_000.tbl_mock_123 AS tbl_mock_132 LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_135 ON tbl_mock_135.id \u003d tbl_mock_132.mock_121 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_132.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200)\nWHERE ((((((tbl_mock_132.mock_030 IN (11980)) AND (tbl_mock_132.mock_024 \u003d 6)) AND (tbl_mock_132.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_132.mock_115 \u003d 2)) AND (tbl_mock_135.mock_024 \u003d 6)) AND (tbl_mock_135.mock_016 \u003d 1)) AND ((tbl_mock_135.mock_014 \u003c\u003d \u00272022-12-21 23:59:59\u0027) AND (tbl_mock_135.mock_015 \u003e\u003d \u00272022-12-21 00:00:00\u0027)))) tbl_mock_131 ON tbl_mock_131.mock_121 \u003d tbl_mock_001.id RIGHT OUTER JOIN ((SELECT DISTINCT tbl_mock_137.mock_121\nFROM db_mock_000.tbl_mock_111 AS tbl_mock_137 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_137.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200) LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_137.mock_121\nWHERE (((((tbl_mock_137.mock_024 \u003d 6) AND (tbl_mock_137.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_133.mock_016 \u003d 1)) AND (tbl_mock_133.mock_024 \u003d 6)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-21 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-21 00:00:00\u0027))) AND (((((tbl_mock_137.mock_108 \u003d \u0027activity\u0027) AND (tbl_mock_137.mock_115 !\u003d 0)) AND (tbl_mock_137.mock_030 IN (1200))) OR (tbl_mock_137.mock_116 IN (((SELECT tbl_mock_111.mock_121\nFROM db_mock_000.tbl_mock_111\nWHERE (((tbl_mock_111.mock_108 \u003d \u0027deal\u0027) AND (tbl_mock_111.mock_121 \u003d tbl_mock_137.mock_116)) AND (tbl_mock_111.mock_112 !\u003d 0)) AND (tbl_mock_111.mock_030 IN (1200))))))) OR (tbl_mock_137.mock_012 IN (((SELECT tbl_mock_111.mock_121\nFROM db_mock_000.tbl_mock_111\nWHERE (((tbl_mock_111.mock_108 \u003d \u0027customer\u0027) AND (tbl_mock_111.mock_121 \u003d tbl_mock_137.mock_012)) AND (tbl_mock_111.mock_112 !\u003d 0)) AND (tbl_mock_111.mock_030 IN (1200)))))))) UNION (SELECT DISTINCT tbl_mock_138.mock_121\nFROM db_mock_000.tbl_mock_123 AS tbl_mock_138 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_138.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200) LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_138.mock_121\nWHERE (((((tbl_mock_138.mock_024 \u003d 6) AND (tbl_mock_138.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_133.mock_016 \u003d 1)) AND (tbl_mock_133.mock_024 \u003d 6)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-21 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-21 00:00:00\u0027))) AND (((((tbl_mock_138.mock_108 \u003d \u0027activity\u0027) AND (tbl_mock_138.mock_115 !\u003d 0)) AND (tbl_mock_138.mock_030 IN (11980))) OR (tbl_mock_138.mock_116 IN (((SELECT tbl_mock_123.mock_121\nFROM db_mock_000.tbl_mock_123\nWHERE (((tbl_mock_123.mock_108 \u003d \u0027deal\u0027) AND (tbl_mock_123.mock_121 \u003d tbl_mock_138.mock_116)) AND (tbl_mock_123.mock_112 !\u003d 0)) AND (tbl_mock_123.mock_030 IN (11980))))))) OR (tbl_mock_138.mock_012 IN (((SELECT tbl_mock_123.mock_121\nFROM db_mock_000.tbl_mock_123\nWHERE (((tbl_mock_123.mock_108 \u003d \u0027customer\u0027) AND (tbl_mock_123.mock_121 \u003d tbl_mock_138.mock_012)) AND (tbl_mock_123.mock_112 !\u003d 0)) AND (tbl_mock_123.mock_030 IN (11980))))))))) tbl_mock_136 ON tbl_mock_136.mock_121 \u003d tbl_mock_001.id\nWHERE ((tbl_mock_001.mock_016 \u003d 1) AND (1 \u003d 1)) AND (tbl_mock_001.mock_024 \u003d 6) ORDER BY if((abs(timestampdiff(DAY, tbl_mock_001.mock_014, tbl_mock_001.mock_015))) \u003e 0, 1, 0) DESC, tbl_mock_001.mock_014 DESC, tbl_mock_001.id DESC  LIMIT 7) UNION (SELECT tbl_mock_001.id, tbl_mock_001.mock_022, tbl_mock_001.mock_007, tbl_mock_068.mock_087, tbl_mock_068.mock_071, tbl_mock_001.mock_003, tbl_mock_001.mock_014 AS mock_126, tbl_mock_001.mock_015 AS mock_127, tbl_mock_001.mock_021 AS mock_064, tbl_mock_037.mock_099, tbl_mock_037.id AS mock_128, if((abs(timestampdiff(DAY, tbl_mock_001.mock_014, tbl_mock_001.mock_015))) \u003e 0, 1, 0) AS mock_129\nFROM db_mock_000.tbl_mock_001 LEFT OUTER JOIN db_mock_000.tbl_mock_043 ON tbl_mock_043.id \u003d tbl_mock_001.mock_022 LEFT OUTER JOIN db_mock_000.tbl_mock_068 ON tbl_mock_068.id \u003d tbl_mock_043.mock_012 LEFT OUTER JOIN db_mock_000.tbl_mock_037 ON tbl_mock_037.id \u003d tbl_mock_001.mock_037 RIGHT OUTER JOIN ((SELECT DISTINCT tbl_mock_132.mock_121\nFROM db_mock_000.tbl_mock_111 AS tbl_mock_132 LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_132.mock_121 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_132.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200)\nWHERE ((((((tbl_mock_132.mock_030 IN (1200)) AND (tbl_mock_132.mock_024 \u003d 6)) AND (tbl_mock_132.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_132.mock_115 \u003d 2)) AND (tbl_mock_133.mock_024 \u003d 6)) AND (tbl_mock_133.mock_016 \u003d 1)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-22 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-22 00:00:00\u0027))) UNION (SELECT DISTINCT tbl_mock_132.mock_121\nFROM db_mock_000.tbl_mock_123 AS tbl_mock_132 LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_135 ON tbl_mock_135.id \u003d tbl_mock_132.mock_121 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_132.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200)\nWHERE ((((((tbl_mock_132.mock_030 IN (11980)) AND (tbl_mock_132.mock_024 \u003d 6)) AND (tbl_mock_132.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_132.mock_115 \u003d 2)) AND (tbl_mock_135.mock_024 \u003d 6)) AND (tbl_mock_135.mock_016 \u003d 1)) AND ((tbl_mock_135.mock_014 \u003c\u003d \u00272022-12-22 23:59:59\u0027) AND (tbl_mock_135.mock_015 \u003e\u003d \u00272022-12-22 00:00:00\u0027)))) tbl_mock_131 ON tbl_mock_131.mock_121 \u003d tbl_mock_001.id RIGHT OUTER JOIN ((SELECT DISTINCT tbl_mock_137.mock_121\nFROM db_mock_000.tbl_mock_111 AS tbl_mock_137 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_137.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200) LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_137.mock_121\nWHERE (((((tbl_mock_137.mock_024 \u003d 6) AND (tbl_mock_137.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_133.mock_016 \u003d 1)) AND (tbl_mock_133.mock_024 \u003d 6)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-22 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-22 00:00:00\u0027))) AND (((((tbl_mock_137.mock_108 \u003d \u0027activity\u0027) AND (tbl_mock_137.mock_115 !\u003d 0)) AND (tbl_mock_137.mock_030 IN (1200))) OR (tbl_mock_137.mock_116 IN (((SELECT tbl_mock_111.mock_121\nFROM db_mock_000.tbl_mock_111\nWHERE (((tbl_mock_111.mock_108 \u003d \u0027deal\u0027) AND (tbl_mock_111.mock_121 \u003d tbl_mock_137.mock_116)) AND (tbl_mock_111.mock_112 !\u003d 0)) AND (tbl_mock_111.mock_030 IN (1200))))))) OR (tbl_mock_137.mock_012 IN (((SELECT tbl_mock_111.mock_121\nFROM db_mock_000.tbl_mock_111\nWHERE (((tbl_mock_111.mock_108 \u003d \u0027customer\u0027) AND (tbl_mock_111.mock_121 \u003d tbl_mock_137.mock_012)) AND (tbl_mock_111.mock_112 !\u003d 0)) AND (tbl_mock_111.mock_030 IN (1200)))))))) UNION (SELECT DISTINCT tbl_mock_138.mock_121\nFROM db_mock_000.tbl_mock_123 AS tbl_mock_138 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_138.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200) LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_138.mock_121\nWHERE (((((tbl_mock_138.mock_024 \u003d 6) AND (tbl_mock_138.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_133.mock_016 \u003d 1)) AND (tbl_mock_133.mock_024 \u003d 6)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-22 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-22 00:00:00\u0027))) AND (((((tbl_mock_138.mock_108 \u003d \u0027activity\u0027) AND (tbl_mock_138.mock_115 !\u003d 0)) AND (tbl_mock_138.mock_030 IN (11980))) OR (tbl_mock_138.mock_116 IN (((SELECT tbl_mock_123.mock_121\nFROM db_mock_000.tbl_mock_123\nWHERE (((tbl_mock_123.mock_108 \u003d \u0027deal\u0027) AND (tbl_mock_123.mock_121 \u003d tbl_mock_138.mock_116)) AND (tbl_mock_123.mock_112 !\u003d 0)) AND (tbl_mock_123.mock_030 IN (11980))))))) OR (tbl_mock_138.mock_012 IN (((SELECT tbl_mock_123.mock_121\nFROM db_mock_000.tbl_mock_123\nWHERE (((tbl_mock_123.mock_108 \u003d \u0027customer\u0027) AND (tbl_mock_123.mock_121 \u003d tbl_mock_138.mock_012)) AND (tbl_mock_123.mock_112 !\u003d 0)) AND (tbl_mock_123.mock_030 IN (11980))))))))) tbl_mock_136 ON tbl_mock_136.mock_121 \u003d tbl_mock_001.id\nWHERE ((tbl_mock_001.mock_016 \u003d 1) AND (1 \u003d 1)) AND (tbl_mock_001.mock_024 \u003d 6) ORDER BY if((abs(timestampdiff(DAY, tbl_mock_001.mock_014, tbl_mock_001.mock_015))) \u003e 0, 1, 0) DESC, tbl_mock_001.mock_014 DESC, tbl_mock_001.id DESC  LIMIT 7) UNION (SELECT tbl_mock_001.id, tbl_mock_001.mock_022, tbl_mock_001.mock_007, tbl_mock_068.mock_087, tbl_mock_068.mock_071, tbl_mock_001.mock_003, tbl_mock_001.mock_014 AS mock_126, tbl_mock_001.mock_015 AS mock_127, tbl_mock_001.mock_021 AS mock_064, tbl_mock_037.mock_099, tbl_mock_037.id AS mock_128, if((abs(timestampdiff(DAY, tbl_mock_001.mock_014, tbl_mock_001.mock_015))) \u003e 0, 1, 0) AS mock_129\nFROM db_mock_000.tbl_mock_001 LEFT OUTER JOIN db_mock_000.tbl_mock_043 ON tbl_mock_043.id \u003d tbl_mock_001.mock_022 LEFT OUTER JOIN db_mock_000.tbl_mock_068 ON tbl_mock_068.id \u003d tbl_mock_043.mock_012 LEFT OUTER JOIN db_mock_000.tbl_mock_037 ON tbl_mock_037.id \u003d tbl_mock_001.mock_037 RIGHT OUTER JOIN ((SELECT DISTINCT tbl_mock_132.mock_121\nFROM db_mock_000.tbl_mock_111 AS tbl_mock_132 LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_132.mock_121 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_132.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200)\nWHERE ((((((tbl_mock_132.mock_030 IN (1200)) AND (tbl_mock_132.mock_024 \u003d 6)) AND (tbl_mock_132.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_132.mock_115 \u003d 2)) AND (tbl_mock_133.mock_024 \u003d 6)) AND (tbl_mock_133.mock_016 \u003d 1)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-23 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-23 00:00:00\u0027))) UNION (SELECT DISTINCT tbl_mock_132.mock_121\nFROM db_mock_000.tbl_mock_123 AS tbl_mock_132 LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_135 ON tbl_mock_135.id \u003d tbl_mock_132.mock_121 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_132.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200)\nWHERE ((((((tbl_mock_132.mock_030 IN (11980)) AND (tbl_mock_132.mock_024 \u003d 6)) AND (tbl_mock_132.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_132.mock_115 \u003d 2)) AND (tbl_mock_135.mock_024 \u003d 6)) AND (tbl_mock_135.mock_016 \u003d 1)) AND ((tbl_mock_135.mock_014 \u003c\u003d \u00272022-12-23 23:59:59\u0027) AND (tbl_mock_135.mock_015 \u003e\u003d \u00272022-12-23 00:00:00\u0027)))) tbl_mock_131 ON tbl_mock_131.mock_121 \u003d tbl_mock_001.id RIGHT OUTER JOIN ((SELECT DISTINCT tbl_mock_137.mock_121\nFROM db_mock_000.tbl_mock_111 AS tbl_mock_137 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_137.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200) LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_137.mock_121\nWHERE (((((tbl_mock_137.mock_024 \u003d 6) AND (tbl_mock_137.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_133.mock_016 \u003d 1)) AND (tbl_mock_133.mock_024 \u003d 6)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-23 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-23 00:00:00\u0027))) AND (((((tbl_mock_137.mock_108 \u003d \u0027activity\u0027) AND (tbl_mock_137.mock_115 !\u003d 0)) AND (tbl_mock_137.mock_030 IN (1200))) OR (tbl_mock_137.mock_116 IN (((SELECT tbl_mock_111.mock_121\nFROM db_mock_000.tbl_mock_111\nWHERE (((tbl_mock_111.mock_108 \u003d \u0027deal\u0027) AND (tbl_mock_111.mock_121 \u003d tbl_mock_137.mock_116)) AND (tbl_mock_111.mock_112 !\u003d 0)) AND (tbl_mock_111.mock_030 IN (1200))))))) OR (tbl_mock_137.mock_012 IN (((SELECT tbl_mock_111.mock_121\nFROM db_mock_000.tbl_mock_111\nWHERE (((tbl_mock_111.mock_108 \u003d \u0027customer\u0027) AND (tbl_mock_111.mock_121 \u003d tbl_mock_137.mock_012)) AND (tbl_mock_111.mock_112 !\u003d 0)) AND (tbl_mock_111.mock_030 IN (1200)))))))) UNION (SELECT DISTINCT tbl_mock_138.mock_121\nFROM db_mock_000.tbl_mock_123 AS tbl_mock_138 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_138.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200) LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_138.mock_121\nWHERE (((((tbl_mock_138.mock_024 \u003d 6) AND (tbl_mock_138.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_133.mock_016 \u003d 1)) AND (tbl_mock_133.mock_024 \u003d 6)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-23 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-23 00:00:00\u0027))) AND (((((tbl_mock_138.mock_108 \u003d \u0027activity\u0027) AND (tbl_mock_138.mock_115 !\u003d 0)) AND (tbl_mock_138.mock_030 IN (11980))) OR (tbl_mock_138.mock_116 IN (((SELECT tbl_mock_123.mock_121\nFROM db_mock_000.tbl_mock_123\nWHERE (((tbl_mock_123.mock_108 \u003d \u0027deal\u0027) AND (tbl_mock_123.mock_121 \u003d tbl_mock_138.mock_116)) AND (tbl_mock_123.mock_112 !\u003d 0)) AND (tbl_mock_123.mock_030 IN (11980))))))) OR (tbl_mock_138.mock_012 IN (((SELECT tbl_mock_123.mock_121\nFROM db_mock_000.tbl_mock_123\nWHERE (((tbl_mock_123.mock_108 \u003d \u0027customer\u0027) AND (tbl_mock_123.mock_121 \u003d tbl_mock_138.mock_012)) AND (tbl_mock_123.mock_112 !\u003d 0)) AND (tbl_mock_123.mock_030 IN (11980))))))))) tbl_mock_136 ON tbl_mock_136.mock_121 \u003d tbl_mock_001.id\nWHERE ((tbl_mock_001.mock_016 \u003d 1) AND (1 \u003d 1)) AND (tbl_mock_001.mock_024 \u003d 6) ORDER BY if((abs(timestampdiff(DAY, tbl_mock_001.mock_014, tbl_mock_001.mock_015))) \u003e 0, 1, 0) DESC, tbl_mock_001.mock_014 DESC, tbl_mock_001.id DESC  LIMIT 7) UNION (SELECT tbl_mock_001.id, tbl_mock_001.mock_022, tbl_mock_001.mock_007, tbl_mock_068.mock_087, tbl_mock_068.mock_071, tbl_mock_001.mock_003, tbl_mock_001.mock_014 AS mock_126, tbl_mock_001.mock_015 AS mock_127, tbl_mock_001.mock_021 AS mock_064, tbl_mock_037.mock_099, tbl_mock_037.id AS mock_128, if((abs(timestampdiff(DAY, tbl_mock_001.mock_014, tbl_mock_001.mock_015))) \u003e 0, 1, 0) AS mock_129\nFROM db_mock_000.tbl_mock_001 LEFT OUTER JOIN db_mock_000.tbl_mock_043 ON tbl_mock_043.id \u003d tbl_mock_001.mock_022 LEFT OUTER JOIN db_mock_000.tbl_mock_068 ON tbl_mock_068.id \u003d tbl_mock_043.mock_012 LEFT OUTER JOIN db_mock_000.tbl_mock_037 ON tbl_mock_037.id \u003d tbl_mock_001.mock_037 RIGHT OUTER JOIN ((SELECT DISTINCT tbl_mock_132.mock_121\nFROM db_mock_000.tbl_mock_111 AS tbl_mock_132 LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_132.mock_121 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_132.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200)\nWHERE ((((((tbl_mock_132.mock_030 IN (1200)) AND (tbl_mock_132.mock_024 \u003d 6)) AND (tbl_mock_132.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_132.mock_115 \u003d 2)) AND (tbl_mock_133.mock_024 \u003d 6)) AND (tbl_mock_133.mock_016 \u003d 1)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-24 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-24 00:00:00\u0027))) UNION (SELECT DISTINCT tbl_mock_132.mock_121\nFROM db_mock_000.tbl_mock_123 AS tbl_mock_132 LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_135 ON tbl_mock_135.id \u003d tbl_mock_132.mock_121 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_132.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200)\nWHERE ((((((tbl_mock_132.mock_030 IN (11980)) AND (tbl_mock_132.mock_024 \u003d 6)) AND (tbl_mock_132.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_132.mock_115 \u003d 2)) AND (tbl_mock_135.mock_024 \u003d 6)) AND (tbl_mock_135.mock_016 \u003d 1)) AND ((tbl_mock_135.mock_014 \u003c\u003d \u00272022-12-24 23:59:59\u0027) AND (tbl_mock_135.mock_015 \u003e\u003d \u00272022-12-24 00:00:00\u0027)))) tbl_mock_131 ON tbl_mock_131.mock_121 \u003d tbl_mock_001.id RIGHT OUTER JOIN ((SELECT DISTINCT tbl_mock_137.mock_121\nFROM db_mock_000.tbl_mock_111 AS tbl_mock_137 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_137.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200) LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_137.mock_121\nWHERE (((((tbl_mock_137.mock_024 \u003d 6) AND (tbl_mock_137.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_133.mock_016 \u003d 1)) AND (tbl_mock_133.mock_024 \u003d 6)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-24 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-24 00:00:00\u0027))) AND (((((tbl_mock_137.mock_108 \u003d \u0027activity\u0027) AND (tbl_mock_137.mock_115 !\u003d 0)) AND (tbl_mock_137.mock_030 IN (1200))) OR (tbl_mock_137.mock_116 IN (((SELECT tbl_mock_111.mock_121\nFROM db_mock_000.tbl_mock_111\nWHERE (((tbl_mock_111.mock_108 \u003d \u0027deal\u0027) AND (tbl_mock_111.mock_121 \u003d tbl_mock_137.mock_116)) AND (tbl_mock_111.mock_112 !\u003d 0)) AND (tbl_mock_111.mock_030 IN (1200))))))) OR (tbl_mock_137.mock_012 IN (((SELECT tbl_mock_111.mock_121\nFROM db_mock_000.tbl_mock_111\nWHERE (((tbl_mock_111.mock_108 \u003d \u0027customer\u0027) AND (tbl_mock_111.mock_121 \u003d tbl_mock_137.mock_012)) AND (tbl_mock_111.mock_112 !\u003d 0)) AND (tbl_mock_111.mock_030 IN (1200)))))))) UNION (SELECT DISTINCT tbl_mock_138.mock_121\nFROM db_mock_000.tbl_mock_123 AS tbl_mock_138 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_138.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200) LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_138.mock_121\nWHERE (((((tbl_mock_138.mock_024 \u003d 6) AND (tbl_mock_138.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_133.mock_016 \u003d 1)) AND (tbl_mock_133.mock_024 \u003d 6)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-24 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-24 00:00:00\u0027))) AND (((((tbl_mock_138.mock_108 \u003d \u0027activity\u0027) AND (tbl_mock_138.mock_115 !\u003d 0)) AND (tbl_mock_138.mock_030 IN (11980))) OR (tbl_mock_138.mock_116 IN (((SELECT tbl_mock_123.mock_121\nFROM db_mock_000.tbl_mock_123\nWHERE (((tbl_mock_123.mock_108 \u003d \u0027deal\u0027) AND (tbl_mock_123.mock_121 \u003d tbl_mock_138.mock_116)) AND (tbl_mock_123.mock_112 !\u003d 0)) AND (tbl_mock_123.mock_030 IN (11980))))))) OR (tbl_mock_138.mock_012 IN (((SELECT tbl_mock_123.mock_121\nFROM db_mock_000.tbl_mock_123\nWHERE (((tbl_mock_123.mock_108 \u003d \u0027customer\u0027) AND (tbl_mock_123.mock_121 \u003d tbl_mock_138.mock_012)) AND (tbl_mock_123.mock_112 !\u003d 0)) AND (tbl_mock_123.mock_030 IN (11980))))))))) tbl_mock_136 ON tbl_mock_136.mock_121 \u003d tbl_mock_001.id\nWHERE ((tbl_mock_001.mock_016 \u003d 1) AND (1 \u003d 1)) AND (tbl_mock_001.mock_024 \u003d 6) ORDER BY if((abs(timestampdiff(DAY, tbl_mock_001.mock_014, tbl_mock_001.mock_015))) \u003e 0, 1, 0) DESC, tbl_mock_001.mock_014 DESC, tbl_mock_001.id DESC  LIMIT 7) UNION (SELECT tbl_mock_001.id, tbl_mock_001.mock_022, tbl_mock_001.mock_007, tbl_mock_068.mock_087, tbl_mock_068.mock_071, tbl_mock_001.mock_003, tbl_mock_001.mock_014 AS mock_126, tbl_mock_001.mock_015 AS mock_127, tbl_mock_001.mock_021 AS mock_064, tbl_mock_037.mock_099, tbl_mock_037.id AS mock_128, if((abs(timestampdiff(DAY, tbl_mock_001.mock_014, tbl_mock_001.mock_015))) \u003e 0, 1, 0) AS mock_129\nFROM db_mock_000.tbl_mock_001 LEFT OUTER JOIN db_mock_000.tbl_mock_043 ON tbl_mock_043.id \u003d tbl_mock_001.mock_022 LEFT OUTER JOIN db_mock_000.tbl_mock_068 ON tbl_mock_068.id \u003d tbl_mock_043.mock_012 LEFT OUTER JOIN db_mock_000.tbl_mock_037 ON tbl_mock_037.id \u003d tbl_mock_001.mock_037 RIGHT OUTER JOIN ((SELECT DISTINCT tbl_mock_132.mock_121\nFROM db_mock_000.tbl_mock_111 AS tbl_mock_132 LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_132.mock_121 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_132.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200)\nWHERE ((((((tbl_mock_132.mock_030 IN (1200)) AND (tbl_mock_132.mock_024 \u003d 6)) AND (tbl_mock_132.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_132.mock_115 \u003d 2)) AND (tbl_mock_133.mock_024 \u003d 6)) AND (tbl_mock_133.mock_016 \u003d 1)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-25 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-25 00:00:00\u0027))) UNION (SELECT DISTINCT tbl_mock_132.mock_121\nFROM db_mock_000.tbl_mock_123 AS tbl_mock_132 LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_135 ON tbl_mock_135.id \u003d tbl_mock_132.mock_121 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_132.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200)\nWHERE ((((((tbl_mock_132.mock_030 IN (11980)) AND (tbl_mock_132.mock_024 \u003d 6)) AND (tbl_mock_132.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_132.mock_115 \u003d 2)) AND (tbl_mock_135.mock_024 \u003d 6)) AND (tbl_mock_135.mock_016 \u003d 1)) AND ((tbl_mock_135.mock_014 \u003c\u003d \u00272022-12-25 23:59:59\u0027) AND (tbl_mock_135.mock_015 \u003e\u003d \u00272022-12-25 00:00:00\u0027)))) tbl_mock_131 ON tbl_mock_131.mock_121 \u003d tbl_mock_001.id RIGHT OUTER JOIN ((SELECT DISTINCT tbl_mock_137.mock_121\nFROM db_mock_000.tbl_mock_111 AS tbl_mock_137 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_137.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200) LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_137.mock_121\nWHERE (((((tbl_mock_137.mock_024 \u003d 6) AND (tbl_mock_137.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_133.mock_016 \u003d 1)) AND (tbl_mock_133.mock_024 \u003d 6)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-25 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-25 00:00:00\u0027))) AND (((((tbl_mock_137.mock_108 \u003d \u0027activity\u0027) AND (tbl_mock_137.mock_115 !\u003d 0)) AND (tbl_mock_137.mock_030 IN (1200))) OR (tbl_mock_137.mock_116 IN (((SELECT tbl_mock_111.mock_121\nFROM db_mock_000.tbl_mock_111\nWHERE (((tbl_mock_111.mock_108 \u003d \u0027deal\u0027) AND (tbl_mock_111.mock_121 \u003d tbl_mock_137.mock_116)) AND (tbl_mock_111.mock_112 !\u003d 0)) AND (tbl_mock_111.mock_030 IN (1200))))))) OR (tbl_mock_137.mock_012 IN (((SELECT tbl_mock_111.mock_121\nFROM db_mock_000.tbl_mock_111\nWHERE (((tbl_mock_111.mock_108 \u003d \u0027customer\u0027) AND (tbl_mock_111.mock_121 \u003d tbl_mock_137.mock_012)) AND (tbl_mock_111.mock_112 !\u003d 0)) AND (tbl_mock_111.mock_030 IN (1200)))))))) UNION (SELECT DISTINCT tbl_mock_138.mock_121\nFROM db_mock_000.tbl_mock_123 AS tbl_mock_138 INNER JOIN db_mock_000.tbl_mock_111 AS tbl_mock_134 ON ((((tbl_mock_138.mock_121 \u003d tbl_mock_134.mock_121) AND (tbl_mock_134.mock_024 \u003d 6)) AND (tbl_mock_134.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_134.mock_115 \u003d 2)) AND (tbl_mock_134.mock_030 \u003d 1200) LEFT OUTER JOIN db_mock_000.tbl_mock_001 AS tbl_mock_133 ON tbl_mock_133.id \u003d tbl_mock_138.mock_121\nWHERE (((((tbl_mock_138.mock_024 \u003d 6) AND (tbl_mock_138.mock_108 \u003d \u0027activity\u0027)) AND (tbl_mock_133.mock_016 \u003d 1)) AND (tbl_mock_133.mock_024 \u003d 6)) AND ((tbl_mock_133.mock_014 \u003c\u003d \u00272022-12-25 23:59:59\u0027) AND (tbl_mock_133.mock_015 \u003e\u003d \u00272022-12-25 00:00:00\u0027))) AND (((((tbl_mock_138.mock_108 \u003d \u0027activity\u0027) AND (tbl_mock_138.mock_115 !\u003d 0)) AND (tbl_mock_138.mock_030 IN (11980))) OR (tbl_mock_138.mock_116 IN (((SELECT tbl_mock_123.mock_121\nFROM db_mock_000.tbl_mock_123\nWHERE (((tbl_mock_123.mock_108 \u003d \u0027deal\u0027) AND (tbl_mock_123.mock_121 \u003d tbl_mock_138.mock_116)) AND (tbl_mock_123.mock_112 !\u003d 0)) AND (tbl_mock_123.mock_030 IN (11980))))))) OR (tbl_mock_138.mock_012 IN (((SELECT tbl_mock_123.mock_121\nFROM db_mock_000.tbl_mock_123\nWHERE (((tbl_mock_123.mock_108 \u003d \u0027customer\u0027) AND (tbl_mock_123.mock_121 \u003d tbl_mock_138.mock_012)) AND (tbl_mock_123.mock_112 !\u003d 0)) AND (tbl_mock_123.mock_030 IN (11980))))))))) tbl_mock_136 ON tbl_mock_136.mock_121 \u003d tbl_mock_001.id\nWHERE ((tbl_mock_001.mock_016 \u003d 1) AND (1 \u003d 1)) AND (tbl_mock_001.mock_024 \u003d 6) ORDER BY if((abs(timestampdiff(DAY, tbl_mock_001.mock_014, tbl_mock_001.mock_015))) \u003e 0, 1, 0) DESC, tbl_mock_001.mock_014 DESC, tbl_mock_001.id DESC  LIMIT 7)","table_meta":{"db_mock_000.tbl_mock_001":"CREATE TABLE db_mock_000.tbl_mock_001 (\nid int(11) NOT NULL ,\nmock_024 int(11) ,\nmock_023 varchar(65533) ,\nmock_030 varchar(65533) ,\nmock_021 varchar(65533) ,\nmock_014 datetime ,\nmock_008 varchar(65533) ,\nmock_005 varchar(65533) ,\nmock_006 varchar(65533) ,\nmock_038 varchar(65533) NOT NULL DEFAULT \"6\" ,\nmock_002 varchar(65533) ,\nmock_025 varchar(65533) ,\nmock_029 varchar(65533) ,\nmock_028 varchar(65533) ,\nmock_026 varchar(65533) ,\nmock_027 varchar(65533) ,\nmock_003 varchar(65533) ,\nmock_009 varchar(65533) ,\nmock_010 datetime ,\nmock_016 int(11) NOT NULL DEFAULT \"1\" ,\nmock_017 int(11) NOT NULL DEFAULT \"0\" ,\nmock_042 varchar(65533) ,\nmock_032 varchar(65533) ,\nmock_011 datetime ,\nmock_020 datetime ,\nmock_034 varchar(65533) ,\nmock_031 varchar(65533) ,\nmock_004 varchar(65533) ,\nmock_015 datetime ,\nmock_037 bigint(20) ,\nmock_007 bigint(20) ,\nmock_022 bigint(20) ,\nmock_013 int(11) NOT NULL DEFAULT \"0\" ,\nmock_039 datetime ,\nmock_019 datetime ,\nmock_018 datetime ,\nmock_012 bigint(20) ,\nmock_033 bigint(20) ,\nmock_035 int(11) ,\nmock_036 varchar(65533) ,\nmock_040 varchar(65533) ,\nmock_041 varchar(65533) \n) ENGINE\u003d OLAP\nPRIMARY KEY(id)\nDISTRIBUTED BY HASH(id) BUCKETS 6 \nPROPERTIES (\n\"replication_num\" \u003d \"1\"\n);","db_mock_000.tbl_mock_043":"CREATE TABLE db_mock_000.tbl_mock_043 (\nid int(11) NOT NULL ,\nmock_024 int(11) ,\nmock_030 int(11) NOT NULL ,\nmock_054 varchar(65533) NOT NULL ,\nmock_067 varchar(65533) NOT NULL ,\nmock_064 varchar(65533) ,\nmock_059 varchar(65533) NOT NULL ,\nmock_045 decimal64(15, 2) DEFAULT \"0.00\" ,\nmock_037 int(11) NOT NULL DEFAULT \"0\" ,\nmock_007 int(11) NOT NULL ,\nmock_051 varchar(65533) ,\nmock_055 varchar(65533) NOT NULL ,\nmock_065 datetime NOT NULL ,\nmock_016 int(11) DEFAULT \"1\" ,\nmock_032 varchar(65533) ,\nmock_046 varchar(65533) ,\nmock_050 varchar(65533) ,\nmock_049 varchar(65533) ,\nmock_047 varchar(65533) ,\nmock_048 varchar(65533) ,\nmock_044 varchar(65533) ,\nmock_031 varchar(65533) ,\nmock_034 varchar(65533) ,\nmock_004 varchar(65533) ,\nmock_056 int(11) ,\nmock_012 bigint(20) ,\nmock_060 datetime ,\nmock_061 datetime ,\nmock_058 datetime ,\nmock_062 datetime ,\nmock_057 bigint(20) ,\nmock_063 bigint(20) DEFAULT \"0\" ,\nmock_053 decimal64(15, 2) DEFAULT \"0.00\" ,\nmock_066 varchar(65533) ,\nmock_018 datetime ,\nmock_019 datetime ,\nmock_052 decimal64(15, 2) DEFAULT \"0.00\" ,\nmock_040 varchar(65533) \n) ENGINE\u003d OLAP\nPRIMARY KEY(id)\nDISTRIBUTED BY HASH(id) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" \u003d \"1\"\n);","db_mock_000.tbl_mock_068":"CREATE TABLE db_mock_000.tbl_mock_068 (\nid int(11) NOT NULL ,\nmock_024 int(11) ,\nmock_072 varchar(65533) ,\nmock_073 varchar(65533) ,\nmock_070 int(11) ,\nmock_088 varchar(65533) ,\nmock_089 varchar(65533) ,\nmock_087 varchar(65533) ,\nmock_071 varchar(65533) ,\nmock_083 varchar(65533) ,\nmock_002 varchar(65533) ,\nmock_092 varchar(65533) ,\nmock_082 varchar(65533) ,\nmock_097 int(11) DEFAULT \"1\" ,\nmock_094 varchar(65533) ,\nmock_085 varchar(65533) NOT NULL ,\nmock_096 varchar(65533) ,\nmock_095 varchar(65533) ,\nmock_016 int(11) DEFAULT \"1\" ,\nmock_086 int(11) NOT NULL DEFAULT \"1\" ,\nmock_090 varchar(65533) ,\nmock_011 datetime ,\nmock_020 datetime ,\nmock_069 varchar(65533) ,\nmock_084 varchar(65533) ,\nmock_093 varchar(65533) ,\nmock_076 double NOT NULL DEFAULT \"0.00\" ,\nmock_078 varchar(65533) ,\nmock_074 varchar(65533) ,\nmock_077 varchar(65533) ,\nmock_079 varchar(65533) ,\nmock_091 varchar(65533) ,\nmock_034 varchar(65533) ,\nmock_004 varchar(65533) ,\nmock_075 bigint(20) ,\nmock_080 bigint(20) ,\nmock_081 bigint(20) \n) ENGINE\u003d OLAP\nPRIMARY KEY(id)\nDISTRIBUTED BY HASH(id) BUCKETS 2 \nPROPERTIES (\n\"replication_num\" \u003d \"1\"\n);","db_mock_000.tbl_mock_037":"CREATE TABLE db_mock_000.tbl_mock_037 (\nid int(11) NOT NULL ,\nmock_024 int(11) ,\nmock_087 varchar(65533) NOT NULL ,\nmock_108 varchar(65533) NOT NULL ,\nmock_016 int(11) DEFAULT \"1\" ,\nmock_103 varchar(65533) ,\nmock_099 varchar(65533) ,\nmock_106 int(11) ,\nmock_110 int(11) NOT NULL DEFAULT \"1\" ,\nmock_101 int(11) DEFAULT \"1\" ,\nmock_107 int(11) DEFAULT \"1\" ,\nmock_102 int(11) DEFAULT \"2\" ,\nmock_109 varchar(65533) ,\nmock_105 varchar(65533) DEFAULT \"PDF\u0026EMAIL\" ,\nmock_100 bigint(20) ,\nmock_098 varchar(65533) ,\nmock_104 varchar(65533) NOT NULL DEFAULT \"Enable\" \n) ENGINE\u003d OLAP\nPRIMARY KEY(id)\nDISTRIBUTED BY HASH(id) BUCKETS 1 \nPROPERTIES (\n\"replication_num\" \u003d \"1\"\n);","db_mock_000.tbl_mock_111":"CREATE TABLE db_mock_000.tbl_mock_111 (\nid bigint(20) NOT NULL ,\nmock_024 bigint(20) ,\nmock_030 bigint(20) ,\nmock_108 varchar(65533) ,\nmock_115 bigint(20) ,\nmock_112 largeint(40) ,\nmock_120 bigint(20) ,\nmock_121 bigint(20) ,\nmock_037 int(11) DEFAULT \"1\" ,\nmock_114 datetime ,\nmock_119 datetime ,\nmock_113 bigint(20) ,\nmock_118 bigint(20) ,\nmock_117 int(11) DEFAULT \"0\" ,\nmock_122 datetime ,\nmock_015 datetime ,\nmock_116 bigint(20) ,\nmock_012 bigint(20) ,\nmock_109 varchar(65533) \n) ENGINE\u003d OLAP\nPRIMARY KEY(id)\nDISTRIBUTED BY HASH(id) BUCKETS 6 \nPROPERTIES (\n\"replication_num\" \u003d \"1\"\n);","db_mock_000.tbl_mock_123":"CREATE TABLE db_mock_000.tbl_mock_123 (\nid bigint(20) NOT NULL ,\nmock_024 bigint(20) ,\nmock_030 bigint(20) ,\nmock_108 varchar(65533) ,\nmock_115 bigint(20) ,\nmock_112 bigint(20) ,\nmock_120 bigint(20) ,\nmock_121 bigint(20) ,\nmock_037 int(11) DEFAULT \"1\" ,\nmock_114 datetime ,\nmock_119 datetime ,\nmock_113 bigint(20) ,\nmock_118 bigint(20) ,\nmock_125 bigint(20) ,\nmock_124 bigint(20) ,\nmock_122 datetime ,\nmock_015 datetime ,\nmock_116 bigint(20) ,\nmock_012 bigint(20) ,\nmock_109 varchar(65533) \n) ENGINE\u003d OLAP\nPRIMARY KEY(id)\nDISTRIBUTED BY HASH(id) BUCKETS 6 \nPROPERTIES (\n\"replication_num\" \u003d \"1\"\n);"},"table_row_count":{},"column_statistics":{},"session_variables":"{\"partial_update_mode\":\"auto\",\"cbo_cte_reuse\":true,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":true,\"enable_connector_adaptive_io_tasks\":true,\"tx_isolation\":\"REPEATABLE-READ\",\"enable_hive_metadata_cache_with_insert\":false,\"cbo_cte_reuse_rate_v2\":1.15,\"character_set_results\":\"utf8\",\"enable_count_star_optimization\":true,\"query_excluding_mv_names\":\"\",\"enable_rewrite_simple_agg_to_meta_scan\":false,\"enable_adaptive_sink_dop\":true,\"consistent_hash_virtual_number\":32,\"enable_profile\":false,\"load_mem_limit\":0,\"sql_safe_updates\":0,\"runtime_filter_early_return_selectivity\":0.05,\"enable_local_shuffle_agg\":true,\"disable_function_fold_constants\":false,\"select_ratio_threshold\":0.15,\"query_delivery_timeout\":300,\"collation_database\":\"utf8_general_ci\",\"spill_mem_table_size\":104857600,\"new_planner_agg_stage\":0,\"use_compute_nodes\":-1,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"\",\"profile_limit_fold\":true,\"spill_operator_max_bytes\":1048576000,\"cbo_max_reorder_node_use_dp\":10,\"enable_hive_column_stats\":true,\"enable_groupby_use_output_alias\":false,\"forward_to_leader\":false,\"count_distinct_column_buckets\":1024,\"query_cache_agg_cardinality_limit\":5000000,\"cboPushDownAggregateMode_v1\":-1,\"window_partition_mode\":1,\"enable_tablet_internal_parallel_v2\":true,\"interpolate_passthrough\":true,\"enable_incremental_mv\":false,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"max_pipeline_dop\":64,\"broadcast_right_table_scale_factor\":10,\"materialized_view_rewrite_mode\":\"DEFAULT\",\"enable_simplify_case_when\":true,\"runtime_join_filter_push_down_limit\":1024000,\"big_query_log_cpu_second_threshold\":480,\"div_precision_increment\":4,\"runtime_adaptive_dop_max_block_rows_per_driver_seq\":16384,\"log_rejected_record_num\":0,\"cbo_push_down_distinct_below_window\":true,\"sql_mode_v2\":32,\"prefer_cte_rewrite\":false,\"hdfs_backend_selector_scan_range_shuffle\":false,\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"hive_partition_stats_sample_size\":3000,\"enable_mv_planner\":false,\"profile_timeout\":2,\"cbo_push_down_aggregate\":\"global\",\"spill_encode_level\":7,\"enable_query_dump\":false,\"global_runtime_filter_build_max_size\":67108864,\"enable_rewrite_sum_by_associative_rule\":true,\"query_cache_hot_partition_num\":3,\"enable_prune_complex_types\":true,\"query_cache_type\":0,\"max_parallel_scan_instance_num\":-1,\"query_cache_entry_max_rows\":409600,\"enable_mv_optimizer_trace_log\":false,\"connector_io_tasks_per_scan_operator\":16,\"enable_materialized_view_union_rewrite\":true,\"sql_quote_show_create\":true,\"scan_or_to_union_threshold\":50000000,\"enable_exchange_pass_through\":true,\"runtime_profile_report_interval\":10,\"query_cache_entry_max_bytes\":4194304,\"enable_exchange_perf\":false,\"workgroup_id\":0,\"enable_rewrite_groupingsets_to_union_all\":false,\"transmission_compression_type\":\"NO_COMPRESSION\",\"interactive_timeout\":3600,\"use_page_cache\":true,\"big_query_log_scan_bytes_threshold\":10737418240,\"collation_server\":\"utf8_general_ci\",\"tablet_internal_parallel_mode\":\"auto\",\"enable_pipeline\":true,\"spill_mode\":\"auto\",\"enable_query_debug_trace\":false,\"enable_show_all_variables\":false,\"full_sort_max_buffered_bytes\":16777216,\"wait_timeout\":28800,\"transmission_encode_level\":7,\"query_including_mv_names\":\"\",\"transaction_isolation\":\"REPEATABLE-READ\",\"enable_global_runtime_filter\":true,\"enable_load_profile\":false,\"enable_plan_validation\":true,\"load_transmission_compression_type\":\"NO_COMPRESSION\",\"cbo_enable_low_cardinality_optimize\":true,\"scan_use_query_mem_ratio\":0.3,\"new_planner_optimize_timeout\":3000,\"enable_outer_join_reorder\":true,\"force_schedule_local\":false,\"hudi_mor_force_jni_reader\":false,\"cbo_enable_greedy_join_reorder\":true,\"range_pruner_max_predicate\":100,\"enable_rbo_table_prune\":false,\"spillable_operator_mask\":-1,\"rpc_http_min_size\":2147482624,\"cbo_debug_alive_backend_number\":0,\"global_runtime_filter_probe_min_size\":102400,\"scan_or_to_union_limit\":4,\"enable_cbo_table_prune\":false,\"enable_parallel_merge\":true,\"nested_mv_rewrite_max_level\":3,\"net_write_timeout\":60,\"cbo_prune_shuffle_column_rate\":0.1,\"spill_revocable_max_bytes\":0,\"hash_join_push_down_right_table\":true,\"pipeline_sink_dop\":0,\"broadcast_row_limit\":15000000,\"enable_populate_block_cache\":true,\"exec_mem_limit\":2147483648,\"enable_sort_aggregate\":false,\"query_cache_force_populate\":false,\"runtime_filter_on_exchange_node\":false,\"disable_join_reorder\":false,\"enable_rule_based_materialized_view_rewrite\":true,\"connector_scan_use_query_mem_ratio\":0.3,\"net_buffer_length\":16384,\"cbo_prune_subfield\":true,\"full_sort_max_buffered_rows\":1024000,\"query_timeout\":300,\"connector_io_tasks_slow_io_latency_ms\":50,\"cbo_max_reorder_node\":50,\"enable_distinct_column_bucketization\":false,\"enable_big_query_log\":true,\"analyze_mv\":\"sample\",\"runtime_filter_scan_wait_time\":20,\"enable_sync_materialized_view_rewrite\":true,\"prefer_compute_node\":false,\"enable_strict_type\":false,\"group_concat_max_len\":65535,\"parse_tokens_limit\":3500000,\"chunk_size\":4096,\"global_runtime_filter_probe_min_selectivity\":0.5,\"query_mem_limit\":0,\"enable_filter_unused_columns_in_scan_stage\":true,\"enable_scan_block_cache\":false,\"enable_materialized_view_single_table_view_delta_rewrite\":false,\"auto_increment_increment\":1,\"sql_dialect\":\"StarRocks\",\"big_query_log_scan_rows_threshold\":1000000000,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":true,\"enable_runtime_adaptive_dop\":false,\"cbo_cte_max_limit\":10,\"storage_engine\":\"olap\",\"enable_optimizer_trace_log\":false,\"spill_operator_min_bytes\":52428800,\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"enable_materialized_view_view_delta_rewrite\":true,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"spill_mem_table_num\":2,\"enable_spill\":false,\"pipeline_dop\":0,\"single_node_exec_plan\":false,\"full_sort_late_materialization_v2\":true,\"join_implementation_mode_v2\":\"auto\",\"sql_select_limit\":9223372036854775807,\"enable_materialized_view_rewrite\":true,\"statistic_collect_parallel\":1,\"hdfs_backend_selector_hash_algorithm\":\"consistent\",\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"default_table_compression\":\"lz4_frame\",\"runtime_adaptive_dop_max_output_amplification_factor\":0,\"innodb_read_only\":true,\"spill_mem_limit_threshold\":0.8,\"cbo_reorder_threshold_use_exhaustive\":6,\"enable_predicate_reorder\":false,\"enable_query_cache\":false,\"max_allowed_packet\":33554432,\"time_zone\":\"Asia/Shanghai\",\"enable_multicolumn_global_runtime_filter\":false,\"character_set_server\":\"utf8\",\"cbo_use_nth_exec_plan\":0,\"io_tasks_per_scan_operator\":4,\"parallel_exchange_instance_num\":-1,\"enable_shared_scan\":false,\"allow_default_partition\":false}","be_number":3,"be_core_stat":{"numOfHardwareCoresPerBe":"{\"10003\":4,\"10004\":4,\"10005\":4}","cachedAvgNumOfHardwareCores":4},"exception":[]}